Renaming calculated fields
When you create a calculated field, Results automatically names the field with the prefix qbf- followed by a unique number. For example, Results might name a field qbf-004. While qbf-004 might be a logical name to Results, it is not intuitive. Therefore, you can rename a calculated field with a more descriptive name. For example, if qbf-004 calculates the number of days between the current date and the ship date, rename it Days_To_Ship.
|
To rename a calculated field: |
- Choose Field
Properties. The Properties dialog box appears: - Select the calculated field whose name you want to change from the Name drop-down list.
- Choose Rename. The Rename Field dialog box appears:
- Enter the new calculated field name, then choose OK to rename the field and return to the Properties dialog box.
- Choose OK.
The field name can be up to 32 characters long and consist of alphabetic characters (A-Z or a-z), digits (0-9), and special characters ($, &, #, -, and _). In addition, field names must begin with a letter (a-Z or a-z). The field name must also be unique within the query and cannot contain spaces.